Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4
I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC
In the use of Oracle databases, Backup recovery is the most critical. When the database fails, it can be restored in a timely manner to reduce unnecessary losses. Next I will briefly introduce the import and export of databases, solutions, tables,
Install Oracle 11g in CentOS 6.5
I recently started to learn how to use CentOS and make some records.
References: Install Oracle 11g in Cent OS 6_5 (x86_64)
I. Hardware requirements
1. Memory & swap
Minimum: 1 GB of RAMRecommended: 2 GB of RAM or
Date functionDate functions manipulate Date values (fields of date type), timestamp values (TIMESTAMP, TIMESTAMP with time ZONE, and TIMESTAMP with the fields of the local time ZONE type), and interval values (INTERVAL day to SECOND and INTERVAL
The simplest 11g Active deployment uard (ADG) configuration process (project steps)
I. Environment Introduction:I first installed a set of database software on the two Linux virtual machines db01 and db02, and created a database named woo on the db01
Oracle Database 11g Some important initialization parameters (i)Initialize parameter file locationD:\app\Administrator\admin\orcl1\pfile\init.oraInit.ora1, Diagnostic_destIn 11g, there is a new structure for storing diagnostic information called the
Oracle 11g Data Loading Methods
Data Loading:
SQL * LOADER
External table
Import/Export
SQL * LOADER:
SQL * LOADER is an Oracle tool that can load data from external data files to databases.
The command for running SQL * LOADER is sqlldr.
Two
Oracle 11g R2 rac rman backup script example
1. Switch RAC to archive Mode
1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have
Oracle provides the scott user's re-creation script, and the 11G uses the script to create scott. The simple operation is as follows:
SQL> select * from dba_users where username = 'Scott '; ------ SCOTT has been manually deleted.
No rows selectedSQL>
Simplify the installation of Oracle Database11g on Oracle Linux 5
Directory
1. Introduction of Oracle-validated RPM for oracle Linux2. Install oracle-validated RPM3. Configure the Directory and set the group and permissions of the directory owner4.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.